export const schemaExample = {
  routeName: 'demo',
  menuName: '菜单名称',
  sqlText: `select u.UserName 用户名,  l.UserName 用户, l.LogType 登录类型, l.ClientType 客户端类型, l.RequestResult 结果, count(1) as 次数
            from Log l
            left join [User] u on u.usercode = l.usercode`,
  groupSqlText: `group by  u.UserName ,  l.UserName , l.LogType , l.ClientType , l.RequestResult
order by count(1)`,
  fields: [
    { name: 'LogType', title: '登录类型', type: 'text', isLike: true },
    {
      name: 'operateTime',
      title: '时间',
      type: 'datetime',
    },
    {
      name: 'UserName',
      title: '用户名',
      type: 'select',
      data: 'select UserName as value,UserName as title from [User]',
    },
  ],
  tableToolbar: [
    {
      title: '导出',
      type: 'default',
      action: 'exportXls',
      uri: '/api/sql-reports/export',
      method: 'post',
    },
    {
      title: '刷新',
      type: 'dashed',
      action: 'reload',
      method: 'get',
    },
  ],
};
